Test Profiling Report

Dataset statistics

Number of variables	19
Number of observations	42308
Missing cells	1737
Missing cells (%)	0.2%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	6.5 MiB
Average record size in memory	160.0 B

Variable types

Numeric	7
Categorical	4
DateTime	2
Text	6

Alerts

`LowDoc` is highly imbalanced (64.0%)	Imbalance
`RevLineCr` has 1041 (2.5%) missing values	Missing
`LowDoc` has 520 (1.2%) missing values	Missing
`NoEmp` has 3048 (7.2%) zeros	Zeros
`CreateJob` has 28870 (68.2%) zeros	Zeros
`RetainedJob` has 25988 (61.4%) zeros	Zeros
`FranchiseCode` has 26458 (62.5%) zeros	Zeros
`Sector` has 9821 (23.2%) zeros	Zeros

Reproduction

Analysis started	2024-01-27 16:07:42.745896
Analysis finished	2024-01-27 16:08:02.451343
Duration	19.71 seconds
Software version	ydata-profiling vv4.6.4
Download configuration	config.json

Term
Real number (ℝ)

Distinct	229
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	108.51522

Minimum	0
Maximum	360
Zeros	95
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	661.1 KiB

Quantile statistics

Minimum	0
5-th percentile	12
Q1	56
median	82
Q3	168
95-th percentile	293
Maximum	360
Range	360
Interquartile range (IQR)	112

Descriptive statistics

Standard deviation	84.894703
Coefficient of variation (CV)	0.78232991
Kurtosis	-0.27868668
Mean	108.51522
Median Absolute Deviation (MAD)	30
Skewness	1.0274118
Sum	4591062
Variance	7207.1106
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
82	3502	8.3%
83	2957	7.0%
84	1497	3.5%
57	1359	3.2%
81	1343	3.2%
58	1291	3.1%
59	1090	2.6%
56	1047	2.5%
240	887	2.1%
60	857	2.0%
Other values (219)	26478	62.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	95	0.2%
1	66	0.2%
2	65	0.2%
3	94	0.2%
4	110	0.3%
5	140	0.3%
6	130	0.3%
7	168	0.4%
8	167	0.4%
9	234	0.6%

Value	Count	Frequency (%)
360	2	< 0.1%
325	8	< 0.1%
312	6	< 0.1%
311	20	< 0.1%
310	27	0.1%
309	50	0.1%
308	70	0.2%
306	91	0.2%
303	137	0.3%
302	142	0.3%

NoEmp
Real number (ℝ)

ZEROS

Distinct	190
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	9.6947149

Minimum	0
Maximum	208
Zeros	3048
Zeros (%)	7.2%
Negative	0
Negative (%)	0.0%
Memory size	661.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	2
median	4
Q3	12
95-th percentile	40
Maximum	208
Range	208
Interquartile range (IQR)	10

Descriptive statistics

Standard deviation	17.242651
Coefficient of variation (CV)	1.778562
Kurtosis	40.904384
Mean	9.6947149
Median Absolute Deviation (MAD)	3
Skewness	5.455337
Sum	410164
Variance	297.30903
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
3	5608	13.3%
2	5354	12.7%
4	4791	11.3%
1	4526	10.7%
5	3156	7.5%
0	3048	7.2%
6	1760	4.2%
16	917	2.2%
7	891	2.1%
17	885	2.1%
Other values (180)	11372	26.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3048	7.2%
1	4526	10.7%
2	5354	12.7%
3	5608	13.3%
4	4791	11.3%
5	3156	7.5%
6	1760	4.2%
7	891	2.1%
8	560	1.3%
9	515	1.2%

Value	Count	Frequency (%)
208	1	< 0.1%
201	1	< 0.1%
199	2	< 0.1%
196	1	< 0.1%
195	1	< 0.1%
194	1	< 0.1%
193	2	< 0.1%
192	2	< 0.1%
190	1	< 0.1%
189	3	< 0.1%

NewExist
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	661.1 KiB

1.0	33472
2.0	8836

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	126924
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	2.0
4th row	1.0
5th row	1.0

Common Values

Value	Count	Frequency (%)
1.0	33472	79.1%
2.0	8836	20.9%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1.0	33472	79.1%
2.0	8836	20.9%

Most occurring characters

Value	Count	Frequency (%)
.	42308	33.3%
0	42308	33.3%
1	33472	26.4%
2	8836	7.0%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	84616	66.7%
Other Punctuation	42308	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	42308	50.0%
1	33472	39.6%
2	8836	10.4%

Other Punctuation

Value	Count	Frequency (%)
.	42308	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	126924	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	42308	33.3%
0	42308	33.3%
1	33472	26.4%
2	8836	7.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	126924	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	42308	33.3%
0	42308	33.3%
1	33472	26.4%
2	8836	7.0%

CreateJob
Real number (ℝ)

ZEROS

Distinct	49
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1865605

Minimum	0
Maximum	86
Zeros	28870
Zeros (%)	68.2%
Negative	0
Negative (%)	0.0%
Memory size	661.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	13
Maximum	86
Range	86
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	5.1316801
Coefficient of variation (CV)	2.3469189
Kurtosis	27.637784
Mean	2.1865605
Median Absolute Deviation (MAD)	0
Skewness	4.2278179
Sum	92509
Variance	26.33414
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=49)

Value	Count	Frequency (%)
0	28870	68.2%
3	3327	7.9%
1	2457	5.8%
4	1443	3.4%
8	677	1.6%
9	601	1.4%
7	570	1.3%
10	518	1.2%
2	491	1.2%
11	389	0.9%
Other values (39)	2965	7.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	28870	68.2%
1	2457	5.8%
2	491	1.2%
3	3327	7.9%
4	1443	3.4%
5	88	0.2%
6	228	0.5%
7	570	1.3%
8	677	1.6%
9	601	1.4%

Value	Count	Frequency (%)
86	2	< 0.1%
75	1	< 0.1%
70	1	< 0.1%
60	3	< 0.1%
57	3	< 0.1%
56	7	< 0.1%
50	9	< 0.1%
48	14	< 0.1%
47	12	< 0.1%
46	18	< 0.1%

RetainedJob
Real number (ℝ)

ZEROS

Distinct	85
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.4996455

Minimum	0
Maximum	175
Zeros	25988
Zeros (%)	61.4%
Negative	0
Negative (%)	0.0%
Memory size	661.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	15
Maximum	175
Range	175
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	8.1344985
Coefficient of variation (CV)	2.3243779
Kurtosis	49.299653
Mean	3.4996455
Median Absolute Deviation (MAD)	0
Skewness	5.4665105
Sum	148063
Variance	66.170066
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	25988	61.4%
1	3822	9.0%
8	1223	2.9%
3	1071	2.5%
9	1063	2.5%
7	1017	2.4%
10	821	1.9%
11	791	1.9%
4	771	1.8%
2	768	1.8%
Other values (75)	4973	11.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	25988	61.4%
1	3822	9.0%
2	768	1.8%
3	1071	2.5%
4	771	1.8%
5	317	0.7%
6	532	1.3%
7	1017	2.4%
8	1223	2.9%
9	1063	2.5%

Value	Count	Frequency (%)
175	2	< 0.1%
136	1	< 0.1%
130	1	< 0.1%
125	4	< 0.1%
118	1	< 0.1%
110	3	< 0.1%
102	1	< 0.1%
100	5	< 0.1%
95	2	< 0.1%
91	2	< 0.1%

FranchiseCode
Real number (ℝ)

ZEROS

Distinct	271
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2025.0608

Minimum	0
Maximum	90709
Zeros	26458
Zeros (%)	62.5%
Negative	0
Negative (%)	0.0%
Memory size	661.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	1
Maximum	90709
Range	90709
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	10633.754
Coefficient of variation (CV)	5.2510787
Kurtosis	34.228771
Mean	2025.0608
Median Absolute Deviation (MAD)	0
Skewness	5.7895406
Sum	85676274
Variance	1.1307672 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	26458	62.5%
1	13878	32.8%
960	174	0.4%
24902	18	< 0.1%
29887	17	< 0.1%
28555	15	< 0.1%
35320	15	< 0.1%
30229	15	< 0.1%
27260	14	< 0.1%
34850	14	< 0.1%
Other values (261)	1690	4.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	26458	62.5%
1	13878	32.8%
960	174	0.4%
10461	1	< 0.1%
10481	1	< 0.1%
10484	4	< 0.1%
10528	1	< 0.1%
10580	1	< 0.1%
10621	3	< 0.1%
10676	2	< 0.1%

Value	Count	Frequency (%)
90709	1	< 0.1%
89785	2	< 0.1%
89769	2	< 0.1%
89655	1	< 0.1%
89640	2	< 0.1%
89352	4	< 0.1%
89350	2	< 0.1%
88875	1	< 0.1%
87350	1	< 0.1%
86720	4	< 0.1%

RevLineCr
Categorical

MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	1041
Missing (%)	2.5%
Memory size	661.1 KiB

N	27829
Y	7454
0	5346
T	638

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	41267
Distinct characters	4
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	T
2nd row	Y
3rd row	N
4th row	Y
5th row	N

Common Values

Value	Count	Frequency (%)
N	27829	65.8%
Y	7454	17.6%
0	5346	12.6%
T	638	1.5%
(Missing)	1041	2.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	27829	67.4%
y	7454	18.1%
0	5346	13.0%
t	638	1.5%

Most occurring characters

Value	Count	Frequency (%)
N	27829	67.4%
Y	7454	18.1%
0	5346	13.0%
T	638	1.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	35921	87.0%
Decimal Number	5346	13.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	27829	77.5%
Y	7454	20.8%
T	638	1.8%

Decimal Number

Value	Count	Frequency (%)
0	5346	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	35921	87.0%
Common	5346	13.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	27829	77.5%
Y	7454	20.8%
T	638	1.8%

Common

Value	Count	Frequency (%)
0	5346	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	41267	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	27829	67.4%
Y	7454	18.1%
0	5346	13.0%
T	638	1.5%

LowDoc
Categorical

IMBALANCE MISSING

Distinct	6
Distinct (%)	< 0.1%
Missing	520
Missing (%)	1.2%
Memory size	661.1 KiB

N	34360
Y	5275
0	675
A	561
S	523

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	41788
Distinct characters	6
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	N
2nd row	N
3rd row	N
4th row	N
5th row	Y

Common Values

Value	Count	Frequency (%)
N	34360	81.2%
Y	5275	12.5%
0	675	1.6%
A	561	1.3%
S	523	1.2%
C	394	0.9%
(Missing)	520	1.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
n	34360	82.2%
y	5275	12.6%
0	675	1.6%
a	561	1.3%
s	523	1.3%
c	394	0.9%

Most occurring characters

Value	Count	Frequency (%)
N	34360	82.2%
Y	5275	12.6%
0	675	1.6%
A	561	1.3%
S	523	1.3%
C	394	0.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	41113	98.4%
Decimal Number	675	1.6%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
N	34360	83.6%
Y	5275	12.8%
A	561	1.4%
S	523	1.3%
C	394	1.0%

Decimal Number

Value	Count	Frequency (%)
0	675	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	41113	98.4%
Common	675	1.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
N	34360	83.6%
Y	5275	12.8%
A	561	1.4%
S	523	1.3%
C	394	1.0%

Common

Value	Count	Frequency (%)
0	675	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	41788	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
N	34360	82.2%
Y	5275	12.6%
0	675	1.6%
A	561	1.3%
S	523	1.3%
C	394	0.9%

DisbursementDate
Date

Distinct	915
Distinct (%)	2.2%
Missing	160
Missing (%)	0.4%
Memory size	661.1 KiB

Minimum	1977-06-14 00:00:00
Maximum	2073-12-06 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

Sector
Real number (ℝ)

ZEROS

Distinct	24
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.966602

Minimum	0
Maximum	81
Zeros	9821
Zeros (%)	23.2%
Negative	0
Negative (%)	0.0%
Memory size	661.1 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	22
median	33
Q3	44
95-th percentile	72
Maximum	81
Range	81
Interquartile range (IQR)	22

Descriptive statistics

Standard deviation	22.273527
Coefficient of variation (CV)	0.67563915
Kurtosis	-0.8931368
Mean	32.966602
Median Absolute Deviation (MAD)	11
Skewness	-0.12484652
Sum	1394751
Variance	496.11
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
0	9821	23.2%
42	7504	17.7%
33	5109	12.1%
44	3963	9.4%
23	3673	8.7%
61	2577	6.1%
72	2439	5.8%
22	1959	4.6%
62	1163	2.7%
53	906	2.1%
Other values (14)	3194	7.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	9821	23.2%
11	8	< 0.1%
21	24	0.1%
22	1959	4.6%
23	3673	8.7%
31	155	0.4%
32	883	2.1%
33	5109	12.1%
42	7504	17.7%
44	3963	9.4%

Value	Count	Frequency (%)
81	178	0.4%
72	2439	5.8%
71	341	0.8%
62	1163	2.7%
61	2577	6.1%
56	606	1.4%
55	29	0.1%
54	251	0.6%
53	906	2.1%
52	75	0.2%

ApprovalDate
Date

Distinct	3888
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Memory size	661.1 KiB

Minimum	1977-03-11 00:00:00
Maximum	2073-10-17 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

ApprovalFY
Real number (ℝ)

Distinct	38
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2001.5219

Minimum	1974
Maximum	2014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	661.1 KiB

Quantile statistics

Minimum	1974
5-th percentile	1991
Q1	1997
median	2003
Q3	2006
95-th percentile	2010
Maximum	2014
Range	40
Interquartile range (IQR)	9

Descriptive statistics

Standard deviation	5.9015063
Coefficient of variation (CV)	0.0029485095
Kurtosis	0.14880309
Mean	2001.5219
Median Absolute Deviation (MAD)	4
Skewness	-0.69731103
Sum	84680388
Variance	34.827776
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=38)

Value	Count	Frequency (%)
2004	4685	11.1%
2007	3807	9.0%
2003	3299	7.8%
2006	3241	7.7%
2005	2744	6.5%
1995	2411	5.7%
2000	2307	5.5%
1996	1791	4.2%
2008	1729	4.1%
2002	1686	4.0%
Other values (28)	14608	34.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1974	3	< 0.1%
1977	6	< 0.1%
1979	21	< 0.1%
1980	54	0.1%
1981	11	< 0.1%
1982	93	0.2%
1983	67	0.2%
1984	95	0.2%
1985	155	0.4%
1986	68	0.2%

Value	Count	Frequency (%)
2014	6	< 0.1%
2013	101	0.2%
2012	345	0.8%
2011	775	1.8%
2010	976	2.3%
2009	1164	2.8%
2008	1729	4.1%
2007	3807	9.0%
2006	3241	7.7%
2005	2744	6.5%

City
Text

Distinct	2678
Distinct (%)	6.3%
Missing	0
Missing (%)	0.0%
Memory size	661.1 KiB

Length

Max length	30
Median length	27
Mean length	8.895528
Min length	3

Characters and Unicode

Total characters	376352
Distinct characters	69
Distinct categories	9 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	775 ?
Unique (%)	1.8%

Sample

1st row	SUNNYVALE
2nd row	PITTSBURGH
3rd row	LITTLE ROCK
4th row	LITTLE ROCK
5th row	Louisville

Value	Count	Frequency (%)
city	1458	2.7%
san	1305	2.4%
houston	1159	2.1%
pittsburgh	911	1.7%
lake	770	1.4%
salt	672	1.2%
nashville	631	1.2%
pomona	623	1.1%
new	586	1.1%
philadelphia	538	1.0%
Other values (2336)	45860	84.1%

Most occurring characters

Value	Count	Frequency (%)
A	36735	9.8%
E	32561	8.7%
O	29895	7.9%
L	29183	7.8%
N	28977	7.7%
S	24253	6.4%
I	23696	6.3%
R	22017	5.9%
T	20114	5.3%
C	13341	3.5%
Other values (59)	115580	30.7%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	353182	93.8%
Space Separator	12210	3.2%
Lowercase Letter	10059	2.7%
Other Punctuation	383	0.1%
Open Punctuation	315	0.1%
Close Punctuation	181	< 0.1%
Decimal Number	11	< 0.1%
Dash Punctuation	10	< 0.1%
Modifier Symbol	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	36735	10.4%
E	32561	9.2%
O	29895	8.5%
L	29183	8.3%
N	28977	8.2%
S	24253	6.9%
I	23696	6.7%
R	22017	6.2%
T	20114	5.7%
C	13341	3.8%
Other values (16)	92410	26.2%

Lowercase Letter

Value	Count	Frequency (%)
o	1079	10.7%
e	1048	10.4%
a	1010	10.0%
n	992	9.9%
l	925	9.2%
i	817	8.1%
r	781	7.8%
s	612	6.1%
t	523	5.2%
u	325	3.2%
Other values (16)	1947	19.4%

Decimal Number

Value	Count	Frequency (%)
0	3	27.3%
2	2	18.2%
1	2	18.2%
3	1	9.1%
6	1	9.1%
8	1	9.1%
5	1	9.1%

Other Punctuation

Value	Count	Frequency (%)
.	280	73.1%
'	56	14.6%
,	44	11.5%
/	2	0.5%
:	1	0.3%

Space Separator

Value	Count	Frequency (%)
	12210	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	315	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	181	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	10	100.0%

Modifier Symbol

Value	Count	Frequency (%)
`	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	363241	96.5%
Common	13111	3.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	36735	10.1%
E	32561	9.0%
O	29895	8.2%
L	29183	8.0%
N	28977	8.0%
S	24253	6.7%
I	23696	6.5%
R	22017	6.1%
T	20114	5.5%
C	13341	3.7%
Other values (42)	102469	28.2%

Common

Value	Count	Frequency (%)
	12210	93.1%
(	315	2.4%
.	280	2.1%
)	181	1.4%
'	56	0.4%
,	44	0.3%
-	10	0.1%
0	3	< 0.1%
2	2	< 0.1%
1	2	< 0.1%
Other values (7)	8	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	376352	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	36735	9.8%
E	32561	8.7%
O	29895	7.9%
L	29183	7.8%
N	28977	7.7%
S	24253	6.4%
I	23696	6.3%
R	22017	5.9%
T	20114	5.3%
C	13341	3.5%
Other values (59)	115580	30.7%

State
Text

Distinct	51
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	661.1 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	84616
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	CA
2nd row	PA
3rd row	AR
4th row	AR
5th row	KY

Value	Count	Frequency (%)
ca	6934	16.4%
tx	4189	9.9%
ny	2880	6.8%
pa	2731	6.5%
fl	1947	4.6%
oh	1221	2.9%
ut	1143	2.7%
tn	1129	2.7%
wa	1095	2.6%
ma	1029	2.4%
Other values (41)	18010	42.6%

Most occurring characters

Value	Count	Frequency (%)
A	14829	17.5%
C	8869	10.5%
N	8459	10.0%
T	7350	8.7%
M	5516	6.5%
I	4636	5.5%
X	4189	5.0%
O	4163	4.9%
Y	3801	4.5%
L	3463	4.1%
Other values (14)	19341	22.9%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	84616	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	14829	17.5%
C	8869	10.5%
N	8459	10.0%
T	7350	8.7%
M	5516	6.5%
I	4636	5.5%
X	4189	5.0%
O	4163	4.9%
Y	3801	4.5%
L	3463	4.1%
Other values (14)	19341	22.9%

Most occurring scripts

Value	Count	Frequency (%)
Latin	84616	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	14829	17.5%
C	8869	10.5%
N	8459	10.0%
T	7350	8.7%
M	5516	6.5%
I	4636	5.5%
X	4189	5.0%
O	4163	4.9%
Y	3801	4.5%
L	3463	4.1%
Other values (14)	19341	22.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	84616	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	14829	17.5%
C	8869	10.5%
N	8459	10.0%
T	7350	8.7%
M	5516	6.5%
I	4636	5.5%
X	4189	5.0%
O	4163	4.9%
Y	3801	4.5%
L	3463	4.1%
Other values (14)	19341	22.9%

BankState
Text

Distinct	52
Distinct (%)	0.1%
Missing	16
Missing (%)	< 0.1%
Memory size	661.1 KiB

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	84584
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	CA
2nd row	PA
3rd row	AR
4th row	AR
5th row	DE

Value	Count	Frequency (%)
ca	6491	15.3%
nc	3266	7.7%
il	2947	7.0%
oh	2878	6.8%
ri	2586	6.1%
tx	2525	6.0%
sd	2285	5.4%
ny	2159	5.1%
pa	1227	2.9%
ut	1119	2.6%
Other values (42)	14809	35.0%

Most occurring characters

Value	Count	Frequency (%)
A	11324	13.4%
C	10833	12.8%
N	8768	10.4%
I	7456	8.8%
O	5266	6.2%
T	5156	6.1%
L	4251	5.0%
M	3987	4.7%
D	3756	4.4%
H	3339	3.9%
Other values (14)	20448	24.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	84584	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	11324	13.4%
C	10833	12.8%
N	8768	10.4%
I	7456	8.8%
O	5266	6.2%
T	5156	6.1%
L	4251	5.0%
M	3987	4.7%
D	3756	4.4%
H	3339	3.9%
Other values (14)	20448	24.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	84584	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	11324	13.4%
C	10833	12.8%
N	8768	10.4%
I	7456	8.8%
O	5266	6.2%
T	5156	6.1%
L	4251	5.0%
M	3987	4.7%
D	3756	4.4%
H	3339	3.9%
Other values (14)	20448	24.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	84584	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	11324	13.4%
C	10833	12.8%
N	8768	10.4%
I	7456	8.8%
O	5266	6.2%
T	5156	6.1%
L	4251	5.0%
M	3987	4.7%
D	3756	4.4%
H	3339	3.9%
Other values (14)	20448	24.2%

DisbursementGross
Text

Distinct	2659
Distinct (%)	6.3%
Missing	0
Missing (%)	0.0%
Memory size	661.1 KiB

Length

Max length	14
Median length	12
Mean length	11.491018
Min length	10

Characters and Unicode

Total characters	486162
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	615 ?
Unique (%)	1.5%

Sample

1st row	$25,000.00
2nd row	$15,000.00
3rd row	$28,000.00
4th row	$7,500.00
5th row	$91,000.00

Value	Count	Frequency (%)
100,000.00	2671	6.3%
50,000.00	2168	5.1%
25,000.00	1425	3.4%
5,000.00	1230	2.9%
60,000.00	1072	2.5%
150,000.00	935	2.2%
80,000.00	918	2.2%
145,000.00	791	1.9%
10,000.00	753	1.8%
17,000.00	720	1.7%
Other values (2649)	29625	70.0%

Most occurring characters

Value	Count	Frequency (%)
0	216896	44.6%
,	43211	8.9%
$	42308	8.7%
.	42308	8.7%
	42308	8.7%
5	20915	4.3%
1	18498	3.8%
2	13195	2.7%
3	9657	2.0%
4	9032	1.9%
Other values (4)	27834	5.7%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	316027	65.0%
Other Punctuation	85519	17.6%
Currency Symbol	42308	8.7%
Space Separator	42308	8.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	216896	68.6%
5	20915	6.6%
1	18498	5.9%
2	13195	4.2%
3	9657	3.1%
4	9032	2.9%
7	7882	2.5%
6	7591	2.4%
8	6554	2.1%
9	5807	1.8%

Other Punctuation

Value	Count	Frequency (%)
,	43211	50.5%
.	42308	49.5%

Currency Symbol

Value	Count	Frequency (%)
$	42308	100.0%

Space Separator

Value	Count	Frequency (%)
	42308	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	486162	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	216896	44.6%
,	43211	8.9%
$	42308	8.7%
.	42308	8.7%
	42308	8.7%
5	20915	4.3%
1	18498	3.8%
2	13195	2.7%
3	9657	2.0%
4	9032	1.9%
Other values (4)	27834	5.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	486162	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	216896	44.6%
,	43211	8.9%
$	42308	8.7%
.	42308	8.7%
	42308	8.7%
5	20915	4.3%
1	18498	3.8%
2	13195	2.7%
3	9657	2.0%
4	9032	1.9%
Other values (4)	27834	5.7%

GrAppv
Text

Distinct	1410
Distinct (%)	3.3%
Missing	0
Missing (%)	0.0%
Memory size	661.1 KiB

Length

Max length	14
Median length	12
Mean length	11.467146
Min length	10

Characters and Unicode

Total characters	485152
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	251 ?
Unique (%)	0.6%

Sample

1st row	$25,000.00
2nd row	$15,000.00
3rd row	$28,000.00
4th row	$7,500.00
5th row	$93,000.00

Value	Count	Frequency (%)
100,000.00	3158	7.5%
50,000.00	3077	7.3%
25,000.00	2145	5.1%
10,000.00	1376	3.3%
5,000.00	1365	3.2%
60,000.00	1127	2.7%
150,000.00	1027	2.4%
80,000.00	940	2.2%
15,000.00	882	2.1%
30,000.00	866	2.0%
Other values (1400)	26345	62.3%

Most occurring characters

Value	Count	Frequency (%)
0	233805	48.2%
,	43226	8.9%
$	42308	8.7%
.	42308	8.7%
	42308	8.7%
5	20670	4.3%
1	16062	3.3%
2	11835	2.4%
3	7344	1.5%
4	6509	1.3%
Other values (4)	18777	3.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	315002	64.9%
Other Punctuation	85534	17.6%
Currency Symbol	42308	8.7%
Space Separator	42308	8.7%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	233805	74.2%
5	20670	6.6%
1	16062	5.1%
2	11835	3.8%
3	7344	2.3%
4	6509	2.1%
7	5654	1.8%
6	5505	1.7%
8	4472	1.4%
9	3146	1.0%

Other Punctuation

Value	Count	Frequency (%)
,	43226	50.5%
.	42308	49.5%

Currency Symbol

Value	Count	Frequency (%)
$	42308	100.0%

Space Separator

Value	Count	Frequency (%)
	42308	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	485152	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	233805	48.2%
,	43226	8.9%
$	42308	8.7%
.	42308	8.7%
	42308	8.7%
5	20670	4.3%
1	16062	3.3%
2	11835	2.4%
3	7344	1.5%
4	6509	1.3%
Other values (4)	18777	3.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	485152	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	233805	48.2%
,	43226	8.9%
$	42308	8.7%
.	42308	8.7%
	42308	8.7%
5	20670	4.3%
1	16062	3.3%
2	11835	2.4%
3	7344	1.5%
4	6509	1.3%
Other values (4)	18777	3.9%

SBA_Appv
Text

Distinct	1992
Distinct (%)	4.7%
Missing	0
Missing (%)	0.0%
Memory size	661.1 KiB

Length

Max length	14
Median length	11
Mean length	11.283776
Min length	10

Characters and Unicode

Total characters	477394
Distinct characters	14
Distinct categories	4 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	416 ?
Unique (%)	1.0%

Sample

1st row	$21,250.00
2nd row	$7,500.00
3rd row	$23,800.00
4th row	$6,375.00
5th row	$93,000.00

Value	Count	Frequency (%)
25,000.00	2438	5.8%
12,500.00	1688	4.0%
90,000.00	998	2.4%
5,000.00	997	2.4%
50,000.00	964	2.3%
4,250.00	920	2.2%
116,000.00	777	1.8%
51,000.00	775	1.8%
80,000.00	706	1.7%
13,600.00	704	1.7%
Other values (1982)	31341	74.1%

Most occurring characters

Value	Count	Frequency (%)
0	192785	40.4%
,	42743	9.0%
$	42308	8.9%
.	42308	8.9%
	42308	8.9%
5	28618	6.0%
2	18888	4.0%
1	18451	3.9%
3	9781	2.0%
7	9704	2.0%
Other values (4)	29500	6.2%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	307727	64.5%
Other Punctuation	85051	17.8%
Currency Symbol	42308	8.9%
Space Separator	42308	8.9%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	192785	62.6%
5	28618	9.3%
2	18888	6.1%
1	18451	6.0%
3	9781	3.2%
7	9704	3.2%
6	8122	2.6%
4	7716	2.5%
8	7044	2.3%
9	6618	2.2%

Other Punctuation

Value	Count	Frequency (%)
,	42743	50.3%
.	42308	49.7%

Currency Symbol

Value	Count	Frequency (%)
$	42308	100.0%

Space Separator

Value	Count	Frequency (%)
	42308	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	477394	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	192785	40.4%
,	42743	9.0%
$	42308	8.9%
.	42308	8.9%
	42308	8.9%
5	28618	6.0%
2	18888	4.0%
1	18451	3.9%
3	9781	2.0%
7	9704	2.0%
Other values (4)	29500	6.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	477394	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	192785	40.4%
,	42743	9.0%
$	42308	8.9%
.	42308	8.9%
	42308	8.9%
5	28618	6.0%
2	18888	4.0%
1	18451	3.9%
3	9781	2.0%
7	9704	2.0%
Other values (4)	29500	6.2%

UrbanRural
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	661.1 KiB

0	24344
1	11508
2	6456

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	42308
Distinct characters	3
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	0
3rd row	1
4th row	2
5th row	0

Common Values

Value	Count	Frequency (%)
0	24344	57.5%
1	11508	27.2%
2	6456	15.3%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	24344	57.5%
1	11508	27.2%
2	6456	15.3%

Most occurring characters

Value	Count	Frequency (%)
0	24344	57.5%
1	11508	27.2%
2	6456	15.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	42308	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	24344	57.5%
1	11508	27.2%
2	6456	15.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	42308	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	24344	57.5%
1	11508	27.2%
2	6456	15.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	42308	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	24344	57.5%
1	11508	27.2%
2	6456	15.3%

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	Term	NoEmp	NewExist	CreateJob	RetainedJob	FranchiseCode	RevLineCr	LowDoc	DisbursementDate	Sector	ApprovalDate	ApprovalFY	City	State	BankState	DisbursementGross	GrAppv	SBA_Appv	UrbanRural
42307	5	2	1.0	1	0	0	T	N	31-Jul-04	23	6-Aug-07	2007	SUNNYVALE	CA	CA	$25,000.00	$25,000.00	$21,250.00	1
42308	235	13	1.0	9	14	77725	Y	N	11-Jan-95	44	8-Mar-04	2004	PITTSBURGH	PA	PA	$15,000.00	$15,000.00	$7,500.00	0
42309	31	5	2.0	0	0	0	N	NaN	NaN	56	27-Feb-07	2007	LITTLE ROCK	AR	AR	$28,000.00	$28,000.00	$23,800.00	1
42310	120	4	1.0	0	1	0	Y	N	30-Apr-99	62	19-Dec-97	1998	LITTLE ROCK	AR	AR	$7,500.00	$7,500.00	$6,375.00	2
42311	63	13	1.0	0	8	1	N	N	31-Dec-05	42	10-Jul-09	2009	Louisville	KY	DE	$91,000.00	$93,000.00	$93,000.00	0
42312	83	2	1.0	17	8	80555	0	Y	31-Oct-94	23	30-Nov-94	1995	ORLANDO	FL	FL	$100,000.00	$100,000.00	$50,000.00	2
42313	81	3	1.0	0	0	1	Y	N	5-Apr-11	42	9-Dec-04	2005	CHINO	CA	CA	$5,000.00	$5,000.00	$4,250.00	1
42314	32	9	1.0	1	3	0	N	N	1-Feb-10	42	26-Aug-04	2004	SAN MARCOS	TX	TX	$42,000.00	$42,000.00	$33,600.00	1
42315	83	13	1.0	4	9	0	N	N	28-Feb-09	42	13-Dec-05	2006	WEBSTER	MA	MA	$58,547.00	$30,000.00	$15,000.00	1
42316	15	0	2.0	0	0	0	N	N	30-Nov-03	0	27-Oct-06	2007	FORT WORTH	TX	TX	$50,000.00	$50,000.00	$40,000.00	0

	Term	NoEmp	NewExist	CreateJob	RetainedJob	FranchiseCode	RevLineCr	LowDoc	DisbursementDate	Sector	ApprovalDate	ApprovalFY	City	State	BankState	DisbursementGross	GrAppv	SBA_Appv	UrbanRural
84605	60	5	1.0	0	2	1	N	N	5-Jun-92	81	26-Jan-07	2007	INDIANAPOLIS	IN	OH	$250,000.00	$250,000.00	$200,000.00	1
84606	178	5	1.0	0	0	1	N	N	31-Jul-95	0	22-Aug-00	2000	BOISE	ID	ID	$100,000.00	$100,000.00	$80,000.00	0
84607	240	16	1.0	0	0	0	0	N	31-Oct-93	33	13-Apr-89	1989	BUCKEYE	AZ	OR	$282,000.00	$282,000.00	$211,500.00	1
84608	7	3	1.0	14	12	0	N	N	31-May-98	44	21-Dec-90	1991	HUMBOLDT	IA	IA	$152,000.00	$152,000.00	$152,000.00	1
84609	237	2	1.0	0	0	0	N	A	31-Jan-95	72	27-Jul-04	2004	HOUSTON	TX	NC	$4,000.00	$4,000.00	$3,400.00	0
84610	243	10	1.0	3	14	0	N	N	1-Dec-12	42	23-Apr-12	2012	FT. WRIGHT	KY	OH	$390,000.00	$150,000.00	$127,500.00	0
84611	178	0	2.0	0	0	1	N	N	30-Nov-03	0	27-Oct-06	2007	PHILADELPHIA	PA	RI	$100,000.00	$100,000.00	$90,000.00	0
84612	42	1	2.0	3	9	0	Y	N	28-Feb-09	33	21-Sep-89	1989	ELMHURST	IL	IL	$17,000.00	$17,000.00	$13,600.00	0
84613	76	15	1.0	0	0	0	N	N	31-Jan-08	0	3-Apr-06	2006	NASHVILLE	TN	TN	$7,500.00	$7,500.00	$6,375.00	0
84614	35	3	2.0	1	4	18150	Y	S	31-Dec-06	44	13-May-03	2003	EUGENE	OR	OR	$50,700.00	$50,700.00	$25,350.00	1

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Decimal Number

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Space Separator

Open Punctuation

Close Punctuation

Dash Punctuation

Modifier Symbol

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts